﻿create procedure [dbo].[usp_GetTeamMemberByTeam]  
@TeamId as int

as  

select * from TblTeamMembers where TeamId=@TeamId